Program on WebRowset

import java.sql.*;
public class Sample
{
public static void main(String args[])
{
Connection con=null;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:vision","scott","tiger");
Statement st=con.createStatement();
st.executeUpdate(“create table test(eno number(5),
na varchar2(20),sal number(5))”);
st.executeUpdate(“insert into test values(100,’prasad’,3430)”);
st.executeUpdate(“insert into test values(200,’bhanu’,1430)”);
WebRowset webrs=null;
ResultSet rs=null;
Statement st1=con.createStatement();
webrs=new WebRowsetImplement();
webrs.setCommand(“select * from emp where eno=100”);
webrs.execute(con);
FileWriter fw=null;
File f=new File(“1.xml”);
Fw=bew FileWriter(f);
System.out.println(“Location”+f.getAbsolutePath());
Webrs.writeXML(fw);
StringWriter sw=new StringWriter();
Webrs.writeXML(sw);
System.out.println(sw.toString());
fw.flush();
fw.close();
rs.close();
st1.close();
con.close();

                }
catch(ClassNotFoundException e)
{
e.printStackTrace();
}
catch(SQLException e)
{
e.printStackTrace();
}
finally
{
try
{
if(con!=null)
con.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
}
}
}